Having Said that the next portion I am having difficulties to perform after the mass copy and paste has operate I want A different code that should update column A accordingly this sort of that the Work num from sheet two will fill in to each in between duties 2 Successfully Submitted (Awaiting Approval)